Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

the backend is poor

let's consider this study case : try to implement it in Domino, it will be nightmare !

we have 3 tables
Employee (employee id = eid, lastname, firstname, birth date)
Department (department id = did, name)
DepartmentEmployees(did, eid)


A) how to implement the concept of unique key and foreign key (and prevent the dupplicates)
B) how joining tables and displaying result (without dupplicating information!)
department A
employee 124
employee 35
depatment B
employee 5
employee 6
etc ...

C) deleting the "department A" deletes all records in departmentEmployees table
D) if something goes wrong in the deletion process we can rollback
E) after data selection (query view), being able to process datas (by java beans) and then display result (display view)
example :
data selection : employees <= 30 years old / employees > 30 years old
process datas : profit made by department
display view : a graphic chart
F) more enterprise integration : mix data placed in other databases. distributed transactions etc ...


Feedback response number WEBB7NVJHG created by ~Judy Destookonyetsi on 02/02/2009

DB2NSF replacement (~Judy Destookon... 29.Jan.09)
. . Does this mean that DB2 integration... (~Elizabeth Cish... 29.Jan.09)
. . . . . . xpages can incorporate DB2 access (Roland Reddekop... 2.Feb.09)
. . . . . . . . . . Toy or Trojan? (Roland Reddekop... 2.Feb.09)
. . NSFDB2 plans (~Tate Nonkizenl... 29.Jan.09)
. . . . I would suggest that you didn't tal... (~Dana Chulumarf... 29.Jan.09)
. . . . I need View Contention to go away (~Chris Bubfreep... 29.Jan.09)
. . . . . . Writing out to RDBMS (~Dana Chulumarf... 29.Jan.09)
. . . . how would you handle huge #docs and... (~Tanita Asaboos... 29.Jan.09)
. . . . Domino is a repository (~Olga Asaponeso... 2.Feb.09)
. . . . . . Domino/Notes is really business wor... (~Isaac Quetnute... 20.Feb.09)
. . . . . . use the rigth design (Ioan Crisan 20.Feb.09)
. . . . the second Garnet move (~Judy Destookon... 29.Jan.09)
. . . . . . NSFDB2 support available until 2017... (~Tate Nonkizenl... 29.Jan.09)
. . . . . . . . Query views...but requesting which ... (~Nicole Minaber... 30.Jan.09)
. . . . . . . . . . use the agent trigger "when docs ar... (Ioan Crisan 20.Feb.09)
. . . . . . . . . . . . . . actually this one is (Ioan Crisan 24.Feb.09)
. . . . . . . . . . transactions (Pejman Parandi 2.Feb.09)
. . There's more discussion on NSF's po... (~Sanjay Quettum... 29.Jan.09)
. . . . the backend is poor (~Judy Destookon... 2.Feb.09)
. . . . . . Rating something as "Poor" is relat... (~Gus Chukikonyo... 2.Feb.09)
. . . . . . . . . . The idea has long history... (Vladimir Panov 3.Feb.09)
. . . . . . . . . . . . That's very interesting... (~Sanjay Quettum... 3.Feb.09)
. . . . . . . . NSF versus a relational DB (~Sanjay Quettum... 2.Feb.09)
. . . . . . . . . . YES WE CAN :)) (~Judy Destookon... 3.Feb.09)
. . . . . . . . simple applications need relational... (~Judy Destookon... 3.Feb.09)
. . . . . . . . . . LMAO (~Naomi Deskrote... 4.Feb.09)
. . . . . . . . . . . . obscured by clouds (~Judy Destookon... 5.Feb.09)
. . . . . . . . . . . . . . "Happy with what I already have" (~Naomi Deskrote... 7.Feb.09)
. . . . . . . . . . . . . . . . LMAO at "chasing with a pitchfork" (~Sanjay Quettum... 8.Feb.09)
. . . . . . . . . . . . . . . . dynamic queries, triggers ... (~Judy Destookon... 10.Feb.09)
. . . . . . . . . . . . . . . . . . Normalization (~Naomi Deskrote... 10.Feb.09)
. . . . . . . . . . . . . . . . . . . . pet store application (~Judy Destookon... 10.Feb.09)
. . . . . . . . . . . . . . . . . . . . . . Defining your own limitations (~Naomi Deskrote... 12.Feb.09)
. . . . . . . . . . . . . . . . . . . . . . . . eCommerce web sites (~Judy Destookon... 13.Feb.09)
. . . . . . . . . . . . . . . . . . . . . . . . . . I don't think you're clear on the m... (~Naomi Deskrote... 13.Feb.09)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . fact = market <eom> (~Judy Destookon... 13.Feb.09)
. . . . . . . . . . . . . . . . . . . . by the way (~Judy Destookon... 10.Feb.09)
. . . . . . . . . . Trivial (~Naomi Deskrote... 4.Feb.09)
. . . . . . . . . . . . db2nsf (~Judy Destookon... 5.Feb.09)
. . . . . . . . . . . . . . Agreed (~Sanjay Quettum... 5.Feb.09)
. . . . . . . . . . . . Resolving keys in a view (~Olga Asaponeso... 5.Feb.09)
. . . . . . . . . . . . . . Yesterday's complaint (~Naomi Deskrote... 7.Feb.09)
. . . . . . . . . . . . . . . . . . NSFDB2 helped Lotusscript programme... (Nathan T. Freem... 10.Feb.09)
. . . . . . . . . . . . . . . . . . . . . . pureXML (Pejman Parandi 10.Feb.09)
. . . . . . . . . . . . . . . . . . The query views work in all version... (Bruce Lill 24.Feb.09)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS